Customer Statement - Top Perforation

The Customer Statement Top Perforation report is a summary of all open invoices due from a client to the agency. This report can be used a means of collecting accounts receivable balances. This report can be forwarded directly to the client. When run using system defaults, this report will show all open transactions with an ending balance due from the client as of the end date of the report.

To Generate a Customer Statement - Top Perforation Report 

1. On the Primary menu, click REPORTS.
2. On the REPORTS menu, click Reports. The Nexsure Reports dialog box is displayed.

3. In the Report Type list, select Accounting.
4. In the Report Category list, select Accounts Receivable.
5. In the Available Reports list, select Customer Statement Top Perf. 
6. Click OK. The summary tab is displayed showing the report selected in the header area.

7. On the navigation toolbar, click New Report Criteria to go to the Nexsure Reports > Report Criteria dialog box. 

8. Under Organization Information, click [Select]. The Nexsure Organization Criteria dialog box is displayed. 

9. In the Nexsure Organization Criteria dialog box, select the desired organization information (in the Region, Territory, Branch, Department, and Unit lists) to query for the report and click Add.  

Note: If the report is being run for the entire organization it is not necessary to make a selection in the Nexsure Organization Criteria dialog box. Only one Region, Territory, or Branch may be selected for each report. When filtering by Department or Unit, add the Branch first then add the Department or Unit. 

Once information has been added to the Include list, it can be removed by selecting the item and clicking Del to remove individual items or Clear to remove all items. 

10. If the organization information is correct, click OK. The organization information selected is added to the Nexsure Reports > Report Criteria screen. 
11. In the Date Information area, select date filters. Date filters are used to set the beginning and ending date of the report. 

The available options are:

• Date Type: Select either As Of Date or Date Range.
• As Of: Set the end date of the report by using either the calendar dialog box or entering a date in the box.
• Period: Periods can be selected from the Period list, which are based on agency accounting periods or can be entered manually if the desired date range does not fall within the standard accounting periods. Period range filters will return all transactions with a balance due within the date range of the report regardless of the transaction date booked.
• Year: Fiscal years based on the general ledger periods and default to current year.
• Date From: Start date for a selected period.
• Date To: End date for the selected period.

Note: As Of Date and Date Range options will return the same results since the report will pull invoices based on their payment status within the date range of the report, not date booked of the invoice. 

12. In the Transaction Information area, make selections to return data for one client and  filter the report by the client types of Personal or Commercial.

The available options are:

• Client Name: Select one or more client names by clicking the  button. The report will return only those open invoices due from the client selected.
• Client Type: Select from the available Client Type list. The list is dynamic based on the Client Types in the organization.
• Retail Agent: Select one or more retail agents by clicking the button. The report will return only those open invoices for clients where the retail agent is assigned.

13. In the Assignment Information area, make selections to limit report output based on the people assignments and responsibility types at the client level.

The available options are:

• Assignment Name: Limit report output by clicking the button to select one or more people assignments.
• Responsibility: Limit report output based on only the responsibility type selected or can be used to further limit output in conjunction with the Assignment Name.
• Group By: Group report with options of None (default), Assignment Name or Responsibility Type.

14. In the Classified Information area, make selections to filter the report based on Code Class and Code Designation as entered by the agency in SETUP.

The available options are:

• Code Class: Limit report output by one or more code classes by clicking the button.
• Code Designation: Limit report output by one or more code designations by clicking the button.

15. In the Output Options area, make selections to display all transactions within the date range so that account history can be provided to the client. The report criteria can also be utilized to hide or show credit balances on the report.

Note: Using the credit balances filter may affect the ending balance of the report.

The available options are:

• Exclude Zero Balance Invoices: Select Yes to exclude invoices with a zero balance due. Select No to include invoices with a zero balance due.
• Exclude Credit Balance: Limit report output to those transactions with ending balances greater than zero. The selections are Yes and No (default).
• Credit Balances Only: Limit report output to those transactions with credit balances only. The selections are Yes and No (default).
• Show Branch in Header: Print the branch address in the header or a blank header. The selections are Yes and No (default).

16. In the Statement Message area, enter a message that will appear at the bottom of each client’s statement. Enter a message of up to 250 characters.

17. In the Report Format Options area, select one of the options in the Format Type list.

The available formats are:

• PDF: This is the default setting that creates the report in a PDF format. The report data is static and cannot be manipulated.
• XLS: Microsoft® Excel® document that can be manipulated as an .xls file. The report is generated with the same formatting used in the PDF format so cells are merged and data may not be stored in individual cells.
• DOC: Microsoft® Word® document that can be manipulated as a .doc file.
• XLS (unformatted): Microsoft® Excel® document that can be manipulated as an .xls file. The report is generated with no formatting so cells are not merged and data is stored in individual cells, however column headers do not appear and page breaks are not inserted. 

18. In the Nexsure Reports > Report Criteria dialog box, click OK. The Customer Statement - Top Perforation report will start compiling.  

19. To update the compiling status, click Refresh on the navigation toolbar.  

20. Once the report Status is Complete, click the View icon to view the report.   

Related Topics

Working with Reports